CREATE TABLE [dbo].[T_WAREHOUSE_PERSON]
(
[WAREHOUSE_ID] [bigint] NOT NULL,
[PERSON_ID] [bigint] NOT NULL,
[CREATE_DATE] [datetime] NOT NULL,
[DISABLE_DATE] [datetime] NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[T_WAREHOUSE_PERSON] ADD 
CONSTRAINT [PK__T_WAREHO__AB09A6ECC20F1819] PRIMARY KEY CLUSTERED  ([WAREHOUSE_ID], [PERSON_ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[T_WAREHOUSE_PERSON] ADD CONSTRAINT [FK__T_WAREHOU__PERSO__656C112C] FOREIGN KEY ([PERSON_ID]) REFERENCES [dbo].[T_PERSON] ([PERSON_ID])
GO
ALTER TABLE [dbo].[T_WAREHOUSE_PERSON] ADD CONSTRAINT [FK__T_WAREHOU__WAREH__66603565] FOREIGN KEY ([WAREHOUSE_ID]) REFERENCES [dbo].[T_WAREHOUSE] ([WAREHOUSE_ID])
GO
